package com.ckf.login_wx.mapper;

import java.util.List;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.ckf.login_wx.entity.Sell;

import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;

@Repository
public interface SellMapper extends BaseMapper<Sell> {
	@Select("select * from sell where time like concat('%',#{name},'%')")
	public List<Sell> seletime(String name);
	@Select("select * from sell where time2 like concat('%',#{name},'%')")
	public List<Sell> seletime2(String name);
	@Select("select * from sell where time like concat('%',#{name},'%') and saisie =#{saisie}")
	public List<Sell> seletimebyquansaisie(@Param("name") String name,@Param("saisie") String saisie);
	@Select("select * from sell where time like concat('%',#{name},'%') and anq =#{anq}")
	public List<Sell> seletimebyquananq(@Param("name") String name,@Param("anq") String anq);
	@Select("select * from sell where ${likename} like concat('%',#{name},'%')")
	public List<Sell> selectlike(@Param("name") String name,@Param("likename") String likename);
	@Select("select * from sell where ${likename} like concat('%',#{name},'%') and anq =#{anq}")
	public List<Sell> selectlikebyanq(@Param("name") String name,@Param("likename") String likename,@Param("anq") String anq);
}
